<?php 
header("Content-type: text/html; charset=utf-8");
$conn = @mysql_connect('localhost','root','')
      or die('数据库无法连接');
@mysql_select_db('neu-video',$conn)
      or die('数据库不存在');
/*mysql_set_charset('utf-8');*/
$sql = 'select * from users';
$result = mysql_query($sql,$conn);
/*while ($result && ($row = mysql_fetch_assoc($result))!==FALSE) {
	echo $row['uname'].'<br>';
}*/
$users = fetch_array($result);
//var_dump($users);
echo '<table border="1">';
echo '<tr>
<th>用户名</th>
<th>密码</th>
<th>性别</th>
<th>出生日期</th>
<th>爱好</th>
<th>学历</th>
<th>个人简历</th>
<th>照片</th>
</tr>';
foreach ($users as $one) {
	echo '<tr>';
	echo '<td>'.$one['uname'].'</td>';
	echo '<td>'.$one['password'].'</td>';
	echo '<td>'.$one['gender'].'</td>';
	echo '<td>'.$one['birthdate'].'</td>';
	echo '<td>'.$one['hobby'].'</td>';
	echo '<td>'.$one['degree'].'</td>';
	echo '<td>'.$one['intro'].'</td>';
	echo '<td>'.$one['pic'].'</td>';
	echo '</tr>';
}
function fetch_array($Results){
	$arrs = array();
    while ($Results && ($row = mysql_fetch_assoc($Results))!==FALSE) {
	       $arrs[] = $row;
          }
    return $arrs;
	
}